﻿CREATE PROCEDURE usix.s_RepoFile_Update
AS

--if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tu_RepoFile]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
--	DROP TABLE tu_RepoFile

TRUNCATE TABLE usix.t_RepoFile

INSERT INTO usix.t_RepoFile
SELECT * 
--INTO usix.t_RepoFile
FROM AFCBANK.DataMining.dbo.All_RepoFiles

--CREATE  CLUSTERED  INDEX [IX_usix_t_RepoFile_CustID] ON [usix].[t_RepoFile]([Cust ID#]) ON [PRIMARY]
